Business Requirements Document (BRD)

Oracle Fusion Cloud — Inventory Management

Solar Panel Inventory | Energix USA | Construction Phase


Field Details
Document Title BRD – Solar Panel Inventory Management — Construction Phase
Client Energix USA (Energix US, Inc.)
Module Oracle Fusion Inventory Management (SCM)
Related Modules Procurement (PO), Project Costing
Document Version 2.0
Status Draft — Pending Approval (Zvi & Tanya — Tuesday Review)
Prepared By Energix IT — Oracle Fusion Practice
Date May 2026

Table of Contents

  1. Executive Summary
  2. Background & Context
  3. Current State — As-Is
  4. Objectives & Success Criteria
  5. Scope
  6. Stakeholders
  7. Future State — End-to-End Process
  8. Detailed Business Requirements
  9. Integration Architecture
  10. Data Migration Approach
  11. Fit-Gap Analysis
  12. Oracle Configuration Highlights
  13. Assumptions & Dependencies
  14. Open Issues & Decision Log
  15. Glossary

1. Executive Summary

Energix USA is a utility-scale solar energy company currently in active Construction Phase operations across multiple project sites in the United States. Solar panels — the highest-value inventory items — are procured, stored at a third-party warehouse (Thyssenkrupp), and shipped to construction sites as needed. Today, all material tracking occurs outside Oracle Fusion, with only financial values manually reported. This creates significant inventory exposure, cost inaccuracies, and financial blind spots.

Oracle Fusion Inventory was partially configured in 2023 but never operationalized. Existing item master records and subinventory structures must be carefully preserved and extended — not rebuilt.

This BRD defines the To-Be solution, covering:

The solution is designed to maximize automation and minimize manual data entry, with Oracle as the system of record and Thyssenkrupp WMS as the operational source of physical movement truth.


2. Background & Context

2.1 Energix Project Phases

Energix solar projects follow three distinct phases. This document covers Construction Phase only.

Development\nNo inventory involved

Construction\nFocus of this document

Operation\nSpare parts only\nOut of scope

""

2.2 Why Solar Panels?

Solar panels are the highest-value inventory item during construction. They are:

2.3 Historical Context

2023Oracle FusionInventoryconfiguredInitial user attemptto manageinventory failed2023–2026All tracking movedto Excel +ThyssenkruppWMSOnly financialvalues manuallyreportedItem masterrecords preservedin OracleMarch 2026Construction Phaseinventory scopeconfirmedPhysical countrequiredimmediatelyThis BRD initiatedMay 2026Key user reviewcompletedDesign updated perfeedbackTuesday approvalsession with Zviand TanyaOracle Inventory History — Energix USA""

3. Current State — As-Is

3.1 Pain Points Summary

Current State\nPain Points

No Oracle inventory visibility\nAll tracking in Excel + Thyssenkrupp WMS

Manual financial reporting only\nNo automated cost transactions

No financial view by location\nNo price-per-PO visibility

Procurement gaps\nDirect-to-site POs lack project reference\n3PL POs have blank project field

No 3PL integration\nAll communication via email or phone

Existing config risk\nItem master valid but unvalidated\nBeginning balances not loaded

""

3.2 Current Procurement & Delivery Flows (As-Is)

Flow B — Via 3PL Warehouse

PO Created\nProject field often blank

Panels delivered\nto Thyssenkrupp WMS

Thyssenkrupp manages\nphysically and in WMS

PM requests shipment\nby email or phone

Containers shipped to site\nNo Oracle record

Flow A — Direct to Site

PO Created\nProject referenced

Supplier ships directly\nto construction site

Receipt not recorded\nin Oracle

Budget tracked\nmanually

""

4. Objectives & Success Criteria

4.1 Core Objectives

Core ObjectivesClean Data FoundationOracle as System ofRecordWMS-Driven AutomationFinancial Inventory ViewProject Cost AccuracyValidate existing itemmaster and lot structureRe-baselinesubinventories andlocatorsLoad reliable beginningbalances via FBDIAll receipts recorded inOracle against POAll shipments recordedvia WMS-pushed eventsReal-time on-handquantity visibilityThyssenkrupp WMSpushes events to Oraclevia APISpecific Pallet ID trackedper shipmentNo manual re-keying oflot or pallet dataInventory value visible bylocationSummarized financialview across locationsMultiple PO prices trackedper itemMaterial movementstrigger project costtransactionsCapitalization at point ofdelivery to project siteLeftover handling atproject close-out""

4.2 Success Criteria

Criterion Target
% of panel receipts recorded in Oracle 100% at go-live
% of shipments to site recorded in Oracle 100% at go-live
Manual data entry for lot / pallet info 0 — fully auto-populated from Thyssenkrupp API
Oracle vs Thyssenkrupp OHQ discrepancy Detected nightly; resolved within 3 business days
Beginning balance accuracy at go-live 100% post physical count reconciliation
Project cost transactions triggered automatically 100% of material movements to project
Financial inventory report available By location + summarized; updated daily

5. Scope

5.1 In Scope / Out of Scope

Out of Scope

Operation Phase — Spare Parts

Other Regions — IL / PL

Detailed picking / packing\nin Oracle

Item master data setup\nand org assignment

User access and\nsecurity roles

Data cleansing activities

Physical count manual effort

Leftover panel transfer to O&M\npending Finance/Legal decision

In Scope

Energix USA — 1 Inventory Org

Solar Panels — Construction Phase

FG-Construction Subinventory

Procurement: REQ + PO + BPO for First Solar

3PL Receiving via WMS-push API

3PL Shipment tracking via WMS-push API

Project Cost Accounting

OIC Integration with Thyssenkrupp WMS

Nightly Reconciliation Job

Beginning Balance Load via FBDI

Physical Count — 1 cycle

Financial Inventory Report\nby location + summarized

Up to 5 Custom Reports

Up to 8 Integration Interfaces

""

6. Stakeholders

Role Party Responsibility
Process Owner Energix USA Operations Lead Owns inventory process decisions
Material Controller Energix USA Monitors reconciliation; reviews discrepancies
Project Manager (PM) Energix USA PMO Monitors panel delivery to site; tracks consumption
Planner Energix USA Validates 3PL receipt quantities
Finance Energix USA Finance Financial inventory view; capitalization; cost decisions
ERP Manager Energix IT Configuration oversight
Oracle Functional Consultant Energix IT / SI Partner Functional design & implementation
Lead Integration Expert SI Partner OIC integration with Thyssenkrupp WMS
Thyssenkrupp WMS Team Thyssenkrupp 3PL operations; WMS API data provider
First Solar Supplier Primary panel supplier under MSA/BPO

7. Future State — End-to-End Process

7.1 Process Overview

The redesigned process is built on a warehouse-driven model. Oracle does not initiate or manage physical movements — Thyssenkrupp's WMS owns physical operations and pushes events to Oracle via API. Oracle records, costs, and reports.

Unsupported markdown: list

Yes

No

OIC scheduled job\ncompares Oracle OHQ\nvs Thyssenkrupp WMS

Discrepancy?

Alert to\nMaterial Controller

Reconciliation report\nno action required

Unsupported markdown: list

Inventory valued\nby PO price per lot

Financial report\nby location

Financial report\nsummarized across locations

Unsupported markdown: list

Thyssenkrupp physically\nships panels to site

Thyssenkrupp WMS pushes\nshipment event to OIC via API\nincluding specific Pallet ID

OIC posts inventory movement\nin Oracle — Pallet ID recorded

Oracle On-Hand decremented\nProject cost transaction created

Unsupported markdown: list

Supplier delivers\npanels to Thyssenkrupp

Thyssenkrupp processes\nin WMS

PM / Planner validates\nquantities with Thyssenkrupp

OIC receives WMS data\nand posts receipt in Oracle\nLot and Pallet auto-populated

Oracle On-Hand updated\nFG-Construction Subinventory

Unsupported markdown: list

First Solar MSA

Other

Direct to site

Via 3PL

Requisition created\nwith Item No. + Subinventory

Supplier

Release against\nBlanket PO

Standard PO

Destination

PO with project reference

PO — project field blank

""

7.2 Key Design Principle — WMS-Driven Shipment

Oracle does not initiate shipments. Thyssenkrupp WMS is the system of truth for physical panel movements. When panels leave the warehouse, the WMS API pushes the event — including the specific Pallet ID — to Oracle via OIC. Oracle records, costs, and reports.

This eliminates:

Oracle Fusion InventoryOracle Integration CloudThyssenkrupp WMSOracle Fusion InventoryOracle Integration CloudThyssenkrupp WMSPanels physically loaded\nand shipped to siteMaterial ControllerPush shipment event via API\nPallet ID, Item, Qty, DestinationPost inventory movement transaction\nLot = Pallet ID confirmedDecrement FG-Construction OHQ\nCreate project cost transactionMovement confirmation notificationMaterial Controller""

7.3 Pallet ID Tracking

Thyssenkrupp's WMS determines which specific pallet(s) physically leave the warehouse. The API sends the exact Pallet ID to Oracle. Oracle records this as the Lot number for that movement — there is no FIFO logic or picking selection inside Oracle.

Thyssenkrupp WMS\nPhysically ships Pallet X\nAPI pushes: Pallet ID = X

OIC Integration Layer\nReceives event\nMaps Pallet ID to Oracle Lot

Oracle Fusion Inventory\nLot X decremented\nProject cost posted

""

8. Detailed Business Requirements

BR-01 — Material & Lot Structure

Priority: High | Actor: ERP Manager / Oracle Functional Consultant

Requirement:
Maintain and extend the existing Oracle Fusion item master for solar panels. The lot structure must align precisely with Thyssenkrupp's pallet-based tracking system.

Locators

Defined as combinations\nNeeds re-validation

Subinventory

FG – Construction\nActive panels

O&M – Spare Parts\nTo be re-evaluated

Item Master

Prefix: MOD

Lot Controlled\nLot No. = Pallet ID

Manufacturer Part No.\nmatches Thyssenkrupp

Origin and attributes\nin Lot DFF

Pallet to Each UOM\nconversion per module type

""

Business Rules:


BR-02 — Beginning Balance Loading

Priority: Critical | Actor: Material Controller / ERP Manager

Requirement:
Establish reliable beginning balances in Oracle Fusion Inventory using physical count data. Balances are loaded via FBDI in three cycles.

Physical Count\nASAP — at Thyssenkrupp\nSupervised by Energix

Design Phase Load\n~50%\nTest Environment

Test Phase Load\n~90%\nTest Environment\nException Report

Pre Go-Live Count\nFinal — 100%\nSupervised by Energix

Production Load\n100%\nZero exceptions required

""

Existing Inventory Handling:

Scenario Action
Inventory without correct lot number Miscellaneous Issue → re-receive with correct Pallet ID as Lot
Project-assigned inventory already in Oracle Count + validate quantity and cost → decide case-by-case whether to issue and re-receive
Inventory cost discrepancy Validate with Finance → adjust before production load

Business Rules:


BR-03 — Receiving at 3PL Warehouse

Priority: High | Actor: PM / Planner, OIC Integration

Requirement:
When panels arrive at Thyssenkrupp's warehouse, the receipt is recorded in Oracle against the relevant PO. Lot and pallet data are auto-populated from Thyssenkrupp's WMS API — no manual entry.

Oracle FusionOIC IntegrationThyssenkrupp WMSOracle FusionOIC IntegrationThyssenkrupp WMSSupplierPM / PlannerPhysical delivery of panelsReceipt notificationValidate quantities\nand details with TKPush receipt data via API\nLot ID, Pallet ID, MPN, Qty, OriginPost receipt against PO\nAuto-populate lot and pallet fieldsUpdate FG-Construction\nOn-Hand QuantityReceipt confirmationSupplierPM / Planner""

Business Rules:


BR-04 — Shipment from 3PL to Project Site (WMS-Driven)

Priority: High | Actor: Thyssenkrupp WMS (initiator), OIC, Oracle Fusion

Requirement:
When panels are physically shipped from Thyssenkrupp's warehouse to a project site, the Thyssenkrupp WMS pushes the shipment event to Oracle via OIC API. Oracle records the inventory movement and project cost transaction. The PM does not initiate a request in Oracle — the physical shipment drives the Oracle transaction.

Oracle Project CostingOracle Fusion InventoryOracle Integration CloudThyssenkrupp WMSOracle Project CostingOracle Fusion InventoryOracle Integration CloudThyssenkrupp WMSPanels physically shipped to site\nPallet IDs determined by TKCosting SLA updated\nProject SLA updatedMaterial ControllerPush shipment event via REST API\nPallet IDs, Quantities, Project SitePost inventory movement transaction\nLot = exact Pallet ID from WMSDecrement FG-Construction OHQCreate project cost transaction\nCapitalize panels to projectMovement confirmation notificationMaterial Controller""

Business Rules:


BR-05 — Financial Inventory View

Priority: High | Actor: Finance, Material Controller

Requirement:
Because the same solar panel item is purchased across multiple POs at different prices, Energix requires a financial inventory report that provides:

  1. Inventory value by location — on-hand quantity and value per subinventory / locator, showing the price at which each lot was received (linked to the originating PO).
  2. Summarized financial view — total inventory value across all locations, grouped by item, with weighted average or actual cost depending on the costing method agreed with Finance.

Report 2 — Summarized

Item

Total Quantity\nacross all locations

Total Inventory Value

Costing method:\nActual or Weighted Average

Report 1 — By Location

Item + Lot = Pallet ID

Subinventory / Locator

Quantity on Hand

PO Unit Price at Receipt

Inventory Value = Qty × PO Price

Oracle Inventory\nOn-Hand by Lot and Location

""

Business Rules:

Acceptance Criteria:


BR-06 — Consumption & Leftover Handling

Priority: High | Actor: Finance, Material Controller

Requirement:
Panels issued to a project are capitalized. At project close-out, leftovers must be handled per Finance and Legal guidance (pending — see OI-01).

Panels shipped to site\nPallet ID recorded

Issued to project\nCapitalized as project cost

Cycle count performed

Deficiency found

No deficiency

Adjustment posted\nby Material Controller

Project completion

Leftover panels?

Yes\nTransfer to O&M Subinventory\nPending Finance and Legal — OI-01

No leftovers\nInventory zeroed

At_Site

Capitalized

CycleCount

Deficiency

CloseOut

Adjusted

LeftoverCheck

OandM

Closed

""

BR-07 — Nightly Reconciliation

Priority: High | Actor: OIC (automated), Material Controller

Requirement:
A nightly OIC job compares Oracle on-hand quantities against Thyssenkrupp WMS quantities and alerts the Material Controller on any discrepancy.

Yes

No

Nightly OIC Scheduled Job

Query Oracle Fusion\nOn-Hand by Item and Lot

Query Thyssenkrupp WMS\nOn-Hand via REST API

Compare OHQ\nItem + Lot + Location

Discrepancy?

Alert to Material Controller\nDiscrepancy detail report

Reconciliation report\nNo action required

Material Controller\nInvestigates and resolves\nwithin 3 business days

""

Business Rules:


BR-08 — Annual Physical Count

Priority: Medium | Actor: Thyssenkrupp (execution), Material Controller (oversight)

Requirement:
Annual physical count at Thyssenkrupp performed by Thyssenkrupp under Energix Material Controller's supervision. Results reviewed and posted in Oracle.

Business Rules:


9. Integration Architecture

9.1 System Landscape

External

Oracle Cloud

Oracle Fusion ERP — SaaS

Oracle Integration Cloud — Middleware

INT-01 Outbound\nApproved PO to 3PL

INT-02 Inbound\n3PL Receipt to Oracle

INT-03 Outbound\nShipment Advice to 3PL

INT-04 Inbound\nWMS Shipment Event to Oracle

INT-05 Scheduled\nNightly Reconciliation

Error Handling\nRetry and Notifications

Inventory Management

Procurement

Project Costing

REST APIs

Thyssenkrupp WMS\nREST API

Email Notifications\nMaterial Controller

""

9.2 Integration Interfaces

Interface Direction Description Trigger
INT-01 Outbound Approved PO extract shared with Thyssenkrupp PO Approval event
INT-02 Inbound Material receipt data from Thyssenkrupp → Oracle receipt transaction TK WMS push
INT-03 Outbound Error / failure notifications OIC error handler
INT-04 Inbound WMS shipment event → Oracle inventory movement + project cost TK WMS push on shipment
INT-05 Scheduled Nightly OHQ comparison + discrepancy alert OIC nightly scheduler

10. Data Migration Approach

10.1 Migration Process

Extraction\nPhysical count data\nfrom Thyssenkrupp\nand Excel

Mapping\nMap pallet and lot data\nto Oracle item codes

Upload\nFBDI load to Oracle\nby consultant

Reconciliation\nOracle OHQ vs\nphysical count sheet

Validation\nClient sign-off\non beginning balances

""

10.2 FBDI Load Phases

Phase Load % Environment Gate
Design Phase ~50% Test Structural issues identified and resolved
Test Phase ~90% Test Exception report reviewed; all exceptions resolved
Production 100% Production Final physical count complete; zero exceptions

10.3 Existing Inventory Handling

Scenario Action
Correctly lot-numbered inventory Load directly via FBDI
Inventory without lot / incorrectly numbered Miscellaneous Issue → re-receive with correct Pallet ID
Project-assigned inventory in Oracle Count + validate cost → decide to issue and re-receive case-by-case
Cost discrepancy Validate with Finance before production load

11. Fit-Gap Analysis

# Requirement Oracle Fusion Standard Fit / Gap Notes
BR-01 Lot structure — Lot # = Pallet ID, MPN, DFF Standard lot control + DFF ✅ Fit Validate existing config — no rebuild
BR-02 Beginning balance via FBDI Standard FBDI ✅ Fit Physical count prerequisite — critical path
BR-03 Bulk receipt at 3PL — lot auto-populated from WMS Standard PO receipt; lot population requires integration ⚠️ Gap OIC + TK REST API integration required
BR-04 WMS-driven shipment event → Oracle movement No standard WMS push receiver ⚠️ Gap OIC inbound integration for TK shipment push
BR-04a Specific Pallet ID from WMS recorded as Lot Standard lot on inventory transaction ✅ Fit with config OIC must map Pallet ID to Oracle Lot field
BR-05 Financial inventory report — by location + summarized Standard inventory valuation reports (configurable) ⚠️ Gap / Fit Standard reports may require custom configuration for multi-PO price view
BR-06 Project cost transaction on material movement Standard project-linked inventory transaction ✅ Fit Project costing module must be operational
BR-06a Dual SLA posting — Costing + Project Standard Oracle Fusion SLA configuration ✅ Fit with config SLA rules for EPC segment + Project segment
BR-07 Nightly reconciliation with external WMS No standard Oracle reconciliation with 3PL ⚠️ Gap Custom OIC scheduled integration required
BR-08 Annual physical count Standard Oracle cycle count / physical inventory ✅ Fit Setup partially in place

12. Oracle Configuration Highlights

12.1 Inventory Organization

Parameter Value
Inventory Organization 1 — US Construction Phase
Item Prefix MOD
Lot Control Enabled — Lot # = Pallet ID
Costing Method TBD — confirm with Finance (see OI-02)

12.2 Subinventory Structure

Subinventory Purpose Status
FG – Construction Active construction solar panels Active — re-validate
O&M – Spare Parts Operation & maintenance spares To be re-evaluated

12.3 Item Attributes

Attribute Configuration
Lot Number = Pallet ID from Thyssenkrupp WMS
Manufacturer Part Number Matches Thyssenkrupp records
Origin Stored in Lot DFF
UOM Conversion Pallet → Each per module type — validate all types

12.4 Procurement

Parameter Value
Blanket PO First Solar MSA
Requisition Opened with Item No. + Subinventory location
PO — Direct to Site Project + Task referenced
PO — To 3PL Project field blank

12.5 Accounting

Movement Type SLA
All FG-Construction movements Costing SLA — EPC Company segment
Project-related movements Project SLA — recorded as project costs

13. Assumptions & Dependencies

# Type Description
A-01 Assumption No changes will be made to Thyssenkrupp's WMS or external systems
A-02 Assumption On-hand data provided by Energix from physical count at agreed cut-off date
A-03 Assumption All integrations built through OIC as the middleware platform
A-04 Assumption Minimum 3-business-day turnaround from Thyssenkrupp for prerequisite data
A-05 Assumption Physical counting and on-site supervision performed by Energix personnel
A-06 Assumption All direct-to-site POs include a project reference
A-07 Assumption Thyssenkrupp WMS REST API is available and returns Pallet ID, Item, Qty, and Origin per event
D-01 Dependency OIC instance (Gen 3) provisioned — required before integration design begins
D-02 Dependency Network connectivity confirmed: OIC ↔ Oracle Fusion and OIC ↔ Thyssenkrupp WMS
D-03 Dependency Oracle Fusion Inventory, Purchasing, and Project Costing modules operational with REST APIs enabled
D-04 Dependency Thyssenkrupp WMS REST API endpoints documented and accessible to OIC
D-05 Dependency Immediate physical count initiated — blocks beginning balance load
D-06 Dependency Finance & Legal decision on leftover panel O&M transfer (see OI-01)
D-07 Dependency Costing method confirmed by Finance before beginning balance load (see OI-02)

14. Open Issues & Decision Log

ID Issue Owner Due Date Status
OI-01 Leftover Panel Handling — Final process for transferring leftover panels from FG-Construction to O&M subinventory at project close-out. Awaiting Finance & Legal guidance. Finance / Legal TBD 🔴 Open
OI-02 Costing Method — Standard vs Actual cost for solar panels. Must be confirmed with Finance before beginning balance FBDI load. Finance TBD 🔴 Open
OI-03 UOM Conversions — Full list of module types and their Pallet → Each conversion ratios to be provided by Operations. Operations / ERP Manager TBD 🔴 Open
OI-04 Thyssenkrupp API Readiness — Are all required REST API endpoints (receipt data, shipment event with Pallet ID, OHQ data) documented and accessible? Thyssenkrupp / IT TBD 🔴 Open
OI-05 O&M Subinventory Decision — Current O&M subinventory needs re-evaluation: keep, modify, or decommission? Operations / Finance TBD 🔴 Open
OI-06 Immediate Physical Count — Who coordinates the initial count at Thyssenkrupp? Target date? Material Controller ASAP 🔴 Open
OI-07 Existing Unallocated Inventory — Confirm list of incorrectly lot-numbered items to be issued and re-received before go-live. ERP Manager / Finance TBD 🔴 Open
OI-08 Financial Report Format — Confirm with Finance the required columns, groupings, and export format for the financial inventory report. Finance TBD 🔴 Open

15. Glossary

Term Definition
3PL Third-Party Logistics — Thyssenkrupp, who manages panel storage on behalf of Energix
ASN Advance Shipment Notice — notification from supplier or 3PL of incoming goods
BPO Blanket Purchase Order — standing PO used for First Solar MSA-based purchases
Costing SLA Oracle Fusion Subledger Accounting rule for cost accounting — EPC Company segment
EPC Engineering, Procurement & Construction — the company segment for construction cost recording
FBDI File-Based Data Import — Oracle Fusion standard mechanism for bulk data loading
FG-Construction Finished Goods Subinventory used to hold solar panels during Construction Phase
Lot A controlled batch of inventory — in this context Lot # = Pallet ID from Thyssenkrupp
Material Controller Energix role responsible for reconciliation oversight and movement approvals
MOD Item master prefix for solar panel items in Oracle Fusion
MPN Manufacturer Part Number — stored on item/lot master, matching Thyssenkrupp records
MSA Master Service Agreement — framework agreement with First Solar referenced by BPO
O&M Operations & Maintenance — post-construction phase; spare parts in separate subinventory
OHQ On-Hand Quantity — quantity of an item available in inventory at a given location
OIC Oracle Integration Cloud — middleware for system-to-system integrations
Pallet ID Unique identifier of a physical pallet at Thyssenkrupp's warehouse = Oracle Lot #
PM Project Manager
Project SLA Oracle Fusion Subledger Accounting rule for project cost recording
UOM Unit of Measure — Pallet and Each; conversion ratios defined per module type
WMS Warehouse Management System — Thyssenkrupp's system managing physical panel storage and movements
WMS-Driven Design principle: physical WMS events trigger Oracle transactions — not the reverse

Document prepared by Energix IT — Oracle Fusion Practice
Version 2.0 | May 2026 | Draft — Pending Approval: Zvi & Tanya — Tuesday Session